-
Re: Health Formula
There are a few syntax issues in your formula that are causing the errors. If you can write out long-hand what the logic is for your status lights, it's easier to help. Also, does your sheet actually…1 · -
Re: February Question of the Month - Join the conversation and receive a badge
When I was a kid, I wanted to be the first woman President of the United States. I wrote an essay about this in the 6th grade. For some reason, I believed I needed to become a lawyer as the first ste…9 · -
Re: COUNTIFS with a checkbox column
Hi, Christy - I think you have one of two options. If your [Division] column values are fixed (like a drop-down menu rather than freeform entry), you can use this formula: =COUNTIFS(SAM:SAM, 1, Divis…1 · -
Re: Recurring tasks on a fixed date
Hi, Simon. You might try using a calculated field in your worksheet that leverages WEEKDAY. For example, let's say you have a column called [Completion Date]. It is a date column. Let's also assume y…1 · -
Re: IF/AND Statement using text & checkbox
I am assuming that your "In AOP" column is a checkbox column and that the column where you are placing the formula is also a checkbox column. If that's true, this should do it: =IF(AND([Emp…1 ·